package com.company.genealogy.web.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * 提醒Mapper
 */
@Mapper
public interface ReminderMapper {

    /**
     * 获取今日提醒
     */
    @Select("SELECT id, title, content, type, icon, remind_date, remind_time " +
            "FROM reminder " +
            "WHERE remind_date = CURDATE() AND status = 1 " +
            "ORDER BY remind_time ASC")
    List<Map<String, Object>> getTodayReminders();
} 